------------- danh sach lich quan ly theo ngay -----------

CREATE
--ALTER
PROC proc_DanhSachTheoNgay
@ngay int,@thang int, @nam int 
AS

BEGIN
	SELECT * FROM LICHQL WHERE DAY(NgayLenLich) = @ngay AND MONTH(NgayLenLich) = @thang AND YEAR(NgayLenLich)=@nam
END
GO

proc_DanhSachTheoNgay 8,12,2013